InterBase - kodovani???
Otázka od: Jiri Cincura
17. 6. 2004 11:24
Ahoj
mam takovouto tabulku:
CREATE TABLE "DILY"
(
"ID" INTEGER NOT NULL,
"CISLO" INTEGER NOT NULL,
"CD_ID" INTEGER NOT NULL,
"NAME_CZ" VARCHAR(256) CHARACTER SET WIN1250,
"NAME_EN" VARCHAR(256) CHARACTER SET WIN1250,
"INFO" BLOB SUB_TYPE TEXT SEGMENT SIZE 80 CHARACTER SET WIN1250,
PRIMARY KEY ("ID")
);
ALTER TABLE "DILY" ADD FOREIGN KEY ("CD_ID") REFERENCES "CD" ("ID") ON
DELETE CASCADE;
A chci tam vlozit:
insert into dily values (0, 101, 9, 'Zrusena svatba',
'The Pilot/The One
Where It All Began', null);
Delam to pres IB Console, SQL, co bylo k Delphi. Je to IB7, co je v Delphi,
zadne updaty.
A dostanu tuto chybu:
Error at line 1 - arithmetic exception, numeric overflow, or string
truncation
Cannot transliterate character between character sets
SQL - insert into dily values (0, 101, 9, 'Zrusena svatba',
'The Pilot/The
One Where It All Began', null)
Pritom to tam cpu v WIN1250, kdyz to pisu do konzole, ne?
Staci pak odendat >>s<< a jede to.
Nevi nekdo, jak to vyresit, nejsem totiz v DB moc kovany.
--
Jiri Cincura
e-mail: mailto:jiri@cincura.net; mailto:xcincura@informatics.muni.cz
ICQ: 314711544
web: http://www.cincura.net; http://cincura.net/photo
Odpovedá: Jiri Cincura
17. 6. 2004 12:45
Jiri Cincura wrote:
> Ahoj
>
> mam takovouto tabulku:
> CREATE TABLE "DILY"
> (
> "ID" INTEGER NOT NULL,
> "CISLO" INTEGER NOT NULL,
> "CD_ID" INTEGER NOT NULL,
> "NAME_CZ" VARCHAR(256) CHARACTER SET WIN1250,
> "NAME_EN" VARCHAR(256) CHARACTER SET WIN1250,
> "INFO" BLOB SUB_TYPE TEXT SEGMENT SIZE 80 CHARACTER SET WIN1250,
> PRIMARY KEY ("ID") ); ALTER TABLE "DILY" ADD FOREIGN KEY ("CD_ID")
> REFERENCES "CD" ("ID") ON DELETE CASCADE;
>
> A chci tam vlozit:
> insert into dily values (0, 101, 9, 'Zrusena svatba',
'The Pilot/The
> One Where It All Began', null);
>
> Delam to pres IB Console, SQL, co bylo k Delphi. Je to IB7, co je v
> Delphi, zadne updaty.
> A dostanu tuto chybu:
> Error at line 1 - arithmetic exception, numeric overflow, or string
> truncation Cannot transliterate character between character sets
>
> SQL - insert into dily values (0, 101, 9, 'Zrusena svatba',
'The
> Pilot/The One Where It All Began', null)
>
> Pritom to tam cpu v WIN1250, kdyz to pisu do konzole, ne?
>
> Staci pak odendat >>s<< a jede to.
>
> Nevi nekdo, jak to vyresit, nejsem totiz v DB moc kovany.
Ted jsem si vsiml, ze nevite, kde to S s hackem je. Je to v tom
'Zrusena
svatba'.
--
Jiri Cincura
e-mail: mailto:jiri@cincura.net; mailto:xcincura@informatics.muni.cz
ICQ: 314711544
web: http://www.cincura.net; http://cincura.net/photo
Odpovedá: little_bobes@centrum.cz
17. 6. 2004 12:42
V IBConsoli mivam s cestinou stejne problemy, ale staci pred ten cesky text
vlozit _win1250 a jde to.
insert into dily values (0, 101, 9, _WIN1250 'Zrusena svatba',
'The
Pilot/The One Where It All Began', null)
Bob
----- Original Message -----
From: "Jiri Cincura" <jiri@cincura.net>
> A chci tam vlozit:
> insert into dily values (0, 101, 9, 'Zrusena svatba',
'The Pilot/The One
> Where It All Began', null);
>
> Delam to pres IB Console, SQL, co bylo k Delphi. Je to IB7, co je v
Delphi,
> zadne updaty.
> A dostanu tuto chybu:
> Error at line 1 - arithmetic exception, numeric overflow, or string
> truncation
> Cannot transliterate character between character sets
>
> SQL - insert into dily values (0, 101, 9, 'Zrusena svatba',
'The Pilot/The
> One Where It All Began', null)
>
> Pritom to tam cpu v WIN1250, kdyz to pisu do konzole, ne?
>
> Staci pak odendat >>s<< a jede to.
>